CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost'; FLUSH PRIVILEGES;
mysql> create user dbuser33 identified by "passw"; mysql> grant select, insert, update on testdb1.* to 'dbuser33';